package gold.digger;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by fanzhenyu02 on 2020/6/27.
 * common problem solver template.
 */
public class LC185 {
    public long startExecuteTime = System.currentTimeMillis();


    /*
     * @param 此题目参考了别人代码
     * 这是因为问题情况较为复杂
     * 未来需要再次复习此道题目
     * @return:
     */
    class Solution {
        public void solve() {

        }

//        # Write your MySQL query statement below
//
//        SELECT d.Name AS Department, e.Name AS Employee, e.Salary AS Salary
//        FROM Employee e
//        LEFT JOIN Department d ON e.DepartmentId = d.Id
//        WHERE e.Id IN (
//                SELECT e1.Id
//                FROM Employee e1
//                LEFT JOIN Employee e2
//                ON e1.DepartmentId = e2.DepartmentId
//                AND e1.Salary < e2.Salary
//                GROUP BY e1.Id
//                HAVING COUNT(DISTINCT e2.Salary) <= 2
//                )
//        AND e.DepartmentId IN (
//                SELECT Id
//		FROM Department
//        )
//        ORDER BY d.Id ASC, e.Salary DESC
//
//
    }

    public void run() {
        Solution solution = new Solution();
        List<Integer> list = new ArrayList<>();
        System.out.println(solution.toString());
    }

    public static void main(String[] args) throws Exception {
        LC185 an = new LC185();
        an.run();

        System.out.println("\ncurrent solution total execute time: " + (System.currentTimeMillis() - an.startExecuteTime) + " ms.");
    }
}
